CREATE EXTERNAL TABLE jms_ods.tab_barscan_taking_hi(
 `recordid` string COMMENT '记录编号',
 `billcode` string COMMENT '运单编号',
 `listcode` string COMMENT '清单编号',
 `subbillcode` string COMMENT '子单号',
 `transfercode` string COMMENT '转单号',
 `packagecode` string COMMENT '所属袋号',
 `scantype` string COMMENT '扫描类型',
 `nextstation` string COMMENT '上一站或下一站',
 `destination` string COMMENT '目的地点',
 `scanuser` string COMMENT '扫描雇员',
 `inputsite` string COMMENT '录入部门',
 `scantime` timestamp COMMENT '扫描时间',
 `inputtime` timestamp COMMENT '录入时间',
 `operatedate` timestamp COMMENT '操作日期',
 `send_deliver_user` string COMMENT '派件或收件员',
 `sendcustomer` string COMMENT '寄件客户',
 `sendsite` string COMMENT '寄件网点',
 `destsite` string COMMENT '目的网点',
 `transfercenter` string COMMENT '中转中心',
 `pcs` bigint COMMENT '件数',
 `weight` double COMMENT '重量',
 `goodstype` string COMMENT '物品类别',
 `expresstype` string COMMENT '快件类型',
 `shifts` string COMMENT '班次',
 `transfer_deliver_fee` double COMMENT '中转或派件费',
 `networkfee` double COMMENT '网管费',
 `otherfee` double COMMENT '其他费',
 `checkflag` string COMMENT '核算标识',
 `accountflag` bigint COMMENT '对帐标识',
 `receiptflag` tinyint COMMENT '回单标识',
 `returnflag` tinyint COMMENT '退件标识',
 `elescaleflag` string COMMENT '电子秤标识',
 `unrecordflag` tinyint COMMENT '未录单标识',
 `writebackflag` bigint COMMENT '回写标识',
 `lockflag` tinyint COMMENT '锁定标识',
 `remark` string COMMENT '备注',
 `modifyuser` string COMMENT '修改人',
 `modifytime` timestamp COMMENT '修改时间',
 `mobile` string COMMENT '手机号码',
 `pistolid` string COMMENT '巴枪ID',
 `remark1` string COMMENT '备注1',
 `remark2` string COMMENT '备注2',
 `scansitecode` string COMMENT '扫描网点编号',
 `uploadtime` timestamp COMMENT '上传时间',
 `remark3` string COMMENT '备注3',
 `scanusercode` string COMMENT '扫描雇员编号',
 `send_deliver_usercode` string COMMENT '收派员编号',
 `nextstationcode` string COMMENT '上下一站编号',
 `source` string COMMENT '来源',
 `remark5` string COMMENT '备注5',
 `remark6` double COMMENT '备注6',
 `remark4` string COMMENT '备注4',
 `scansiteid` bigint COMMENT '扫描网点ID',
 `nextstationid` bigint COMMENT '上一站/下一站ID',
 `scanuserid` bigint COMMENT '扫描雇员ID',
 `send_deliver_userid` bigint COMMENT '收派员ID')
COMMENT '揽收表'
PARTITIONED BY (
 `dt` string COMMENT '时间分区')
STORED AS parquet
LOCATION
 '/dw/hive/jms_ods.db/external/tab_barscan_taking_hi'